﻿using System;

namespace edowork.com.Model
{
    #region onroad_inventoryInfo

    [Serializable]
    public class onroad_inventoryInfo
    {
        #region Private fields

        protected string _billsno = String.Empty;
        protected string _productcode = String.Empty;
        protected decimal _qty1;
        protected decimal _qty2;

        #endregion

        public onroad_inventoryInfo() { }

        #region Public Properties

        public string Billsno
        {
            get { return _billsno; }
            set { _billsno = value; }
        }

        public string Productcode
        {
            get { return _productcode; }
            set { _productcode = value; }
        }

        public decimal Qty1
        {
            get { return _qty1; }
            set { _qty1 = value; }
        }

        public decimal Qty2
        {
            get { return _qty2; }
            set { _qty2 = value; }
        }

        #endregion

        #region Public SQL Script

        public string SQL_Insert()
        {
            return "insert into onroad_inventory(Billsno,Productcode,Qty1,Qty2) values('{0}','{1}',{2},{3})";
        }

        #endregion

    }

    #endregion
}

